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