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