UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NGo8sOh13cLevuCsQenWXGiOqhWJ4w5p5G0/u7rhSMs='
WHERE
key_id = 'b5f96d5c11e431ee67700474da0ad578573e55ae075abc5917888028f50b8781'
AND (
token = 'NGo8sOh13cLevuCsQenWXGiOqhWJ4w5p5G0/u7rhSMs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)