UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJ7rRERluCqY7BdJ7ipogsuqLQ6hqTCUewqF7ZOJK3s='
WHERE
key_id = 'f770e12033be0b0ca6ffa4b7409a323e470728c5633085b1abc90aab72a2b14a'
AND (
token = 'zJ7rRERluCqY7BdJ7ipogsuqLQ6hqTCUewqF7ZOJK3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)