UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnLcb3Zh2z9p+HD9kkyhehG9syhxMfEq4+Y+NeZgbqM='
WHERE
key_id = '02ef49464df1034baa5a30768b0970617263550294011d531c6541bbcd3b2694'
AND (
token = 'HnLcb3Zh2z9p+HD9kkyhehG9syhxMfEq4+Y+NeZgbqM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)