UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b18vdOp8AEuC1TMOa8tWruFElckpT5HhulA6WoJqSgM='
WHERE
key_id = '3647f96a637f1b82bf7e47e22091258e13b7984f3be140f4a5de8d0ca9007e12'
AND (
token = 'b18vdOp8AEuC1TMOa8tWruFElckpT5HhulA6WoJqSgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)