UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KBp6wEqxZK3mE50UzJmJ7H4mZru629u/1M9PrqwQ2Pk='
WHERE
key_id = '57bfd29f5b7ff9df12e622886e0f8feab0e39d7175d5f646a655310007687751'
AND (
token = 'KBp6wEqxZK3mE50UzJmJ7H4mZru629u/1M9PrqwQ2Pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)