UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l9YsA0saON8pW7EE37YoUyxrfXvMp46OXFuKPeVoUuE='
WHERE
key_id = '9cdb5c6e592b91df2e662f53c277dbc2e724c5f6954e9212b0d77a86451e5f16'
AND (
token = 'l9YsA0saON8pW7EE37YoUyxrfXvMp46OXFuKPeVoUuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)