UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zK2skO0v6AusUvTqTkPldIG07ZPyCzPUf5IZp55CiQw='
WHERE
key_id = '82162c92e238951b4c42f5ac36890e92aa1237e9bf3f6d69af9bf0da52bddb39'
AND (
token = 'zK2skO0v6AusUvTqTkPldIG07ZPyCzPUf5IZp55CiQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)