UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QU7z6TFlZsgYt1XgK0IRbQPnmLimnvsIFzEKr1n+kok='
WHERE
key_id = '397affaabe65f796434a45907e03b526f2d6bffda645edf4199bc443a4955351'
AND (
token = 'QU7z6TFlZsgYt1XgK0IRbQPnmLimnvsIFzEKr1n+kok='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)