UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3v7eCz4PXLAbwWgrbcTZxM+kymw57IJmmwlfwPcsyAw='
WHERE
key_id = 'd02243b9ba4985b156cf0a587e14e90ab49044f10f119dff2a2519edfb2dd5f7'
AND (
token = '3v7eCz4PXLAbwWgrbcTZxM+kymw57IJmmwlfwPcsyAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)