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