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