UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lHc1vCT7ZvlgK/2GUWhxVrznEYUyjzZW6uTwOsLUovA='
WHERE
key_id = '1756a144e8516e7b82ce6b01c7f67abdb268d9454197907317fd6184e335acb2'
AND (
token = 'lHc1vCT7ZvlgK/2GUWhxVrznEYUyjzZW6uTwOsLUovA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)