UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dlU4gSKSk5e51olKmLFQFjZ1sNoRK3z/Zq38yZfAyDU='
WHERE
key_id = 'e7957a6679531efdb38bc0c5c82f76a94fb5eec20c51c1bc71fc68d80aae2163'
AND (
token = 'dlU4gSKSk5e51olKmLFQFjZ1sNoRK3z/Zq38yZfAyDU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)