UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tE7o4O3v72Si4perm/Z6WwnnkgTyA4j7MmHdXVviKGU='
WHERE
key_id = '19fceb46c7c11f7bd5863e3cc9dc6936eaf2f7894ba1566ffa32e4ce2aa56031'
AND (
token = 'tE7o4O3v72Si4perm/Z6WwnnkgTyA4j7MmHdXVviKGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)