UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5jLoTtr50o4UZ7owL6SI5iGsm6VvXIASjQZihB0UCSs='
WHERE
key_id = '4401af7e4ca30f830f1edd6760a8df75613427e1f4e228f8a50aee0600ef1213'
AND (
token = '5jLoTtr50o4UZ7owL6SI5iGsm6VvXIASjQZihB0UCSs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)