UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RRXu5upu6MVT93trHFRWJg8e65Gxfc5WWximNM35es8='
WHERE
key_id = 'bf3047ab26a0eff3a1d9bfa01fb7cb22915dbb9be0f057e9790c8ebad935edf5'
AND (
token = 'RRXu5upu6MVT93trHFRWJg8e65Gxfc5WWximNM35es8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)