UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+F+0vKmFzeidsV/6QA34sOkJO1ovgWEFq1L5XGgVcfU='
WHERE
key_id = '6ab27868cf31aefb73d46b4d39c0c57695ddd2d67b290e2a18504d833daf0793'
AND (
token = '+F+0vKmFzeidsV/6QA34sOkJO1ovgWEFq1L5XGgVcfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)