UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SncNO0308ShAZDVDHyVjLHYUZdt/LJXalAwUjBxA3Zo='
WHERE
key_id = 'e2004b1822eafcc5f3089cdc38a84341fd35e228937c65bae73dceac649cd91a'
AND (
token = 'SncNO0308ShAZDVDHyVjLHYUZdt/LJXalAwUjBxA3Zo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)