UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EkVqbU1fd+xEqj1QfPdH6Iru9ej9Rx22PPqkmmrvUtw='
WHERE
key_id = 'f111f3241e0bc19b1cf5963963cb78a0f873697fcf20f9dc0780992e69de6e40'
AND (
token = 'EkVqbU1fd+xEqj1QfPdH6Iru9ej9Rx22PPqkmmrvUtw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)