UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8sLIH5TeBKeWMoVMhplLbjhTXyB2VyJlK3Q6NjP+AqI='
WHERE
key_id = 'ada1c7e0b6702846ae1b5a8d418ae3995171a01b8065b0ae0be0af1c5473ae5f'
AND (
token = '8sLIH5TeBKeWMoVMhplLbjhTXyB2VyJlK3Q6NjP+AqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)