UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8KM+wfQ8VAfpb1L+i1LuPr0W/6S3ZZDeU1ua2M5VlXU='
WHERE
key_id = 'ad0aac71024df1b8c55b25bc85cd9004303d7dcee74ec9b56589e87c34d432a5'
AND (
token = '8KM+wfQ8VAfpb1L+i1LuPr0W/6S3ZZDeU1ua2M5VlXU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)