UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nWClJM379Tg35dzZaOzmaml3iBHfdi4w3UU+RwEK+TU='
WHERE
key_id = 'c8f0cc2521e306e663710d09813652f9e35bf14a23b8103274c99194ccab5524'
AND (
token = 'nWClJM379Tg35dzZaOzmaml3iBHfdi4w3UU+RwEK+TU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)