UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYcIIN7L57eSgVmuOyLjND90QdbRQxRkina0Pp2jLbI='
WHERE
key_id = '8d765b3ada0775cbf5bfbc64873bbbe7d7dd9c7d50faec4a33b28cd048737453'
AND (
token = 'ZYcIIN7L57eSgVmuOyLjND90QdbRQxRkina0Pp2jLbI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)