UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WHgymmuX794WmT9LKugh6iqn7DPdb7Ij8VrDR4w+lrg='
WHERE
key_id = 'f7bf68949712c531445e4d3aa1b2a0f912903c8a29c80c4623e62b62f4dfa3f4'
AND (
token = 'WHgymmuX794WmT9LKugh6iqn7DPdb7Ij8VrDR4w+lrg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)