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