UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6b4IoxDj/Is0s8BCdoK7YMwaWt6qHhSF1cjqS5jFoow='
WHERE
key_id = 'a9d097611fb31f788e61ef4d88a8454773878776977c08d952e82ab02f9db9ba'
AND (
token = '6b4IoxDj/Is0s8BCdoK7YMwaWt6qHhSF1cjqS5jFoow='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)