UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U9eF9YWIypzlWHnQO3tEell1sIfO9YUFU+5HTe60SiY='
WHERE
key_id = 'd4d6b9313bd0f0c29bec14262df9482ea3674c93b2681d85c3e4504c2afb8bd3'
AND (
token = 'U9eF9YWIypzlWHnQO3tEell1sIfO9YUFU+5HTe60SiY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)