UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5dv/1nQMU5XVz9ThEsfKufMT6YAd8I8ghPItTAskWCk='
WHERE
key_id = '474101714a8dddbdb87ae667dde2a31b452252a84d65615aee78414d45d1b11a'
AND (
token = '5dv/1nQMU5XVz9ThEsfKufMT6YAd8I8ghPItTAskWCk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)