UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8cmuwF3/O3879CXFOSxA1SbXsPDeh3e8yAMPcgPa8kY='
WHERE
key_id = 'c0ef8b7850b8c7b7a908069affb334dd54b56cd86ba905c3f7942c4225a4d0fd'
AND (
token = '8cmuwF3/O3879CXFOSxA1SbXsPDeh3e8yAMPcgPa8kY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)