UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vTKNKC61GCFjrRWu3NVXFHHkUGVVKfxQuIEz5b7YVho='
WHERE
key_id = 'd009ef14daabb4d82113e03ada432d153df3070e94c715dd5a75e7331bfff66d'
AND (
token = 'vTKNKC61GCFjrRWu3NVXFHHkUGVVKfxQuIEz5b7YVho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)