UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DxK9EBhrXCDR0jmGFy5Vwx6Jj51hgDttEFPJfCMnKiM='
WHERE
key_id = 'dd2931478db149170d194ea5e441aaac497ce6ed6169eb19b72d6392d4706675'
AND (
token = 'DxK9EBhrXCDR0jmGFy5Vwx6Jj51hgDttEFPJfCMnKiM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)