UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hShaFbd1L1IPo8UJ6tfw9r4MZlbjIF4ROomBq1q5/iU='
WHERE
key_id = 'fb1d650f10c80348541a1b88adf4c980c5d0e028e72dcc66ec0101ef4a5b4b63'
AND (
token = 'hShaFbd1L1IPo8UJ6tfw9r4MZlbjIF4ROomBq1q5/iU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)