UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5H9hbLsF4KRu+ilriIz9EcYi9Nl0vaVaarFFAVNUT48='
WHERE
key_id = '0f5604923e43bb6921b16d0ce986a501fef8770aa38b9d3c03baf547aea0937f'
AND (
token = '5H9hbLsF4KRu+ilriIz9EcYi9Nl0vaVaarFFAVNUT48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)