UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LMKgn7j5Hx0R/BrdDuWudoxnUbvxZILi06/lNJSJsPI='
WHERE
key_id = 'c21eeb21dc82b9f243c4923de34385a5ef07189b1387cedb089d84733f9d7e9f'
AND (
token = 'LMKgn7j5Hx0R/BrdDuWudoxnUbvxZILi06/lNJSJsPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)