UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4emZjsJO5OHy/zly4QRKhsLoz7m0I7V+pPWLTnx/0Gs='
WHERE
key_id = '6ec5a2a994ac44f007791396f914d73410559982021736ddb0adc498bb5ef409'
AND (
token = '4emZjsJO5OHy/zly4QRKhsLoz7m0I7V+pPWLTnx/0Gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)