UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wXynGJoKrdXo3e9nTbkX+o3L+f59H8i+qZszBaj7P4Q='
WHERE
key_id = 'e595e4c71c450cfc9843c087ceddab422b36e75b6a1b7324ee698655075962ae'
AND (
token = 'wXynGJoKrdXo3e9nTbkX+o3L+f59H8i+qZszBaj7P4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)