UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9rAOthSFtWGrZDXKxgmlH0GOs7VkP0IF/y+H6IB90k0='
WHERE
key_id = '6924729078a7831b5175db155559e1fb743b415ca769e2d161ab396af8101450'
AND (
token = '9rAOthSFtWGrZDXKxgmlH0GOs7VkP0IF/y+H6IB90k0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)