UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8r3rpdFF4tPHwHEckERSlk8ujWzET7IXEruxLKzGvJ0='
WHERE
key_id = 'db78407dbc4669290c012ea139c6f65023f070be86df0f141c655f01e86c19a1'
AND (
token = '8r3rpdFF4tPHwHEckERSlk8ujWzET7IXEruxLKzGvJ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)