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