UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Nj0Q5xi3zbnZpx8MxSNYwvAOXeHWrIRPKWy6W1UIOTs='
WHERE
key_id = '192f338eb8f188cf7a5d848e8d477c7e70f3ec469b8feadca8ec483d5b504d77'
AND (
token = 'Nj0Q5xi3zbnZpx8MxSNYwvAOXeHWrIRPKWy6W1UIOTs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)