UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NtzSgyZ6F7RaaW+aAjqFL4TeVuck+Rd9UszxzTQvUU='
WHERE
key_id = '8f67eb23e1212715f37a8f4ff99e8e39733021d879350270a629bd99176a88ad'
AND (
token = '8NtzSgyZ6F7RaaW+aAjqFL4TeVuck+Rd9UszxzTQvUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)