UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oDGG6XyPesjJzS3OYy8SUbr5sBUm4uQ85VzYZECmDVU='
WHERE
key_id = '8e692d21366321b298e5baec353ce42b74650c8910a94260f3a56169a3b5ed8a'
AND (
token = 'oDGG6XyPesjJzS3OYy8SUbr5sBUm4uQ85VzYZECmDVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)